USE [TrioJFLApp]
GO

/****** Object:  StoredProcedure [dbo].[sp_Upload_SAP_ProdOrderMaterialReq_ByPE]    Script Date: 09/26/2018 15:45:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[sp_Upload_SAP_ProdOrderMaterialReq_ByPE]
@Material_Number NVARCHAR(50),
@Material_description NVARCHAR(50),
@Order_item_quantity DECIMAL(18,0),
@Order_unit_of_meas  NVARCHAR(50),
@Remark NVARCHAR(100),
@Creator NVARCHAR(50),
@Oid UNIQUEIDENTIFIER
AS 
BEGIN
 UPDATE sp SET 
 sp.Material_Number = @Material_Number
,sp.Material_description=@Material_description
,sp.Order_item_quantity=@Order_item_quantity
,sp.Order_unit_of_meas =@Order_unit_of_meas
,sp.Remark=@Remark
,sp.PE_User= @Creator
,sp.PE_Date=GETDATE()
  FROM SAP_ProdOrderMaterialReq sp
 WHERE sp.Oid=@Oid

END
GO


